Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 2,000 |
| Missing cells | 471 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 343.9 KiB |
| Average record size in memory | 176.1 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 8 |
| Categorical | 7 |
| Boolean | 5 |
| DateTime | 1 |
area_sqm is highly overall correlated with bedrooms and 1 other fields | High correlation |
bathrooms is highly overall correlated with bedrooms | High correlation |
bedrooms is highly overall correlated with area_sqm and 2 other fields | High correlation |
compound_name is highly overall correlated with district | High correlation |
district is highly overall correlated with compound_name | High correlation |
price_egp is highly overall correlated with area_sqm and 1 other fields | High correlation |
compound_name has 471 (23.5%) missing values | Missing |
listing_id has unique values | Unique |
building_age_years has 78 (3.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-11 17:33:54.914747 |
|---|---|
| Analysis finished | 2025-11-11 17:34:00.914843 |
| Duration | 6 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
listing_id
Text
Unique
| Distinct | 2000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 2,000 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | NCR-2024-00001 |
|---|---|
| 2nd row | NCR-2024-00002 |
| 3rd row | NCR-2024-00003 |
| 4th row | NCR-2024-00004 |
| 5th row | NCR-2024-00005 |
| Value | Count | Frequency (%) |
| ncr-2024-01985 | 1 | < 0.1% |
| ncr-2024-01986 | 1 | < 0.1% |
| ncr-2024-01987 | 1 | < 0.1% |
| ncr-2024-01988 | 1 | < 0.1% |
| ncr-2024-01989 | 1 | < 0.1% |
| ncr-2024-01990 | 1 | < 0.1% |
| ncr-2024-01991 | 1 | < 0.1% |
| ncr-2024-01992 | 1 | < 0.1% |
| ncr-2024-01993 | 1 | < 0.1% |
| ncr-2024-01994 | 1 | < 0.1% |
| Other values (1990) | 1990 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 5599 | |
| 2 | 4601 | |
| - | 4000 | |
| 4 | 2600 | |
| C | 2000 | 7.1% |
| N | 2000 | 7.1% |
| R | 2000 | 7.1% |
| 1 | 1600 | 5.7% |
| 9 | 600 | 2.1% |
| 8 | 600 | 2.1% |
| Other values (4) | 2400 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 28000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5599 | |
| 2 | 4601 | |
| - | 4000 | |
| 4 | 2600 | |
| C | 2000 | 7.1% |
| N | 2000 | 7.1% |
| R | 2000 | 7.1% |
| 1 | 1600 | 5.7% |
| 9 | 600 | 2.1% |
| 8 | 600 | 2.1% |
| Other values (4) | 2400 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 28000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5599 | |
| 2 | 4601 | |
| - | 4000 | |
| 4 | 2600 | |
| C | 2000 | 7.1% |
| N | 2000 | 7.1% |
| R | 2000 | 7.1% |
| 1 | 1600 | 5.7% |
| 9 | 600 | 2.1% |
| 8 | 600 | 2.1% |
| Other values (4) | 2400 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 28000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 5599 | |
| 2 | 4601 | |
| - | 4000 | |
| 4 | 2600 | |
| C | 2000 | 7.1% |
| N | 2000 | 7.1% |
| R | 2000 | 7.1% |
| 1 | 1600 | 5.7% |
| 9 | 600 | 2.1% |
| 8 | 600 | 2.1% |
| Other values (4) | 2400 |
price_egp
Real number (ℝ)
High correlation
| Distinct | 122 |
|---|---|
| Distinct (%) | 6.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3845500 |
| Minimum | 1250000 |
|---|---|
| Maximum | 8200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 1250000 |
|---|---|
| 5-th percentile | 2200000 |
| Q1 | 3000000 |
| median | 3750000 |
| Q3 | 4600000 |
| 95-th percentile | 5750000 |
| Maximum | 8200000 |
| Range | 6950000 |
| Interquartile range (IQR) | 1600000 |
Descriptive statistics
| Standard deviation | 1117343.5 |
|---|---|
| Coefficient of variation (CV) | 0.2905587 |
| Kurtosis | 0.13053515 |
| Mean | 3845500 |
| Median Absolute Deviation (MAD) | 750000 |
| Skewness | 0.46212358 |
| Sum | 7.691 × 109 |
| Variance | 1.2484565 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3350000 | 43 | 2.1% |
| 4400000 | 42 | 2.1% |
| 3450000 | 39 | 1.9% |
| 3200000 | 39 | 1.9% |
| 3800000 | 38 | 1.9% |
| 3000000 | 38 | 1.9% |
| 2600000 | 37 | 1.8% |
| 3400000 | 37 | 1.8% |
| 3750000 | 37 | 1.8% |
| 3850000 | 37 | 1.8% |
| Other values (112) | 1613 |
| Value | Count | Frequency (%) |
| 1250000 | 1 | 0.1% |
| 1350000 | 1 | 0.1% |
| 1400000 | 4 | |
| 1450000 | 2 | 0.1% |
| 1550000 | 4 | |
| 1650000 | 1 | 0.1% |
| 1700000 | 5 | |
| 1750000 | 4 | |
| 1800000 | 4 | |
| 1850000 | 7 |
| Value | Count | Frequency (%) |
| 8200000 | 2 | |
| 8000000 | 1 | 0.1% |
| 7600000 | 2 | |
| 7500000 | 1 | 0.1% |
| 7350000 | 1 | 0.1% |
| 7300000 | 1 | 0.1% |
| 7250000 | 2 | |
| 7200000 | 1 | 0.1% |
| 7100000 | 4 | |
| 7050000 | 1 | 0.1% |
area_sqm
Real number (ℝ)
High correlation
| Distinct | 205 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 150.721 |
| Minimum | 60 |
|---|---|
| Maximum | 299 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 60 |
|---|---|
| 5-th percentile | 91 |
| Q1 | 116 |
| median | 145 |
| Q3 | 184 |
| 95-th percentile | 217 |
| Maximum | 299 |
| Range | 239 |
| Interquartile range (IQR) | 68 |
Descriptive statistics
| Standard deviation | 43.785703 |
|---|---|
| Coefficient of variation (CV) | 0.29050831 |
| Kurtosis | 0.020600521 |
| Mean | 150.721 |
| Median Absolute Deviation (MAD) | 33 |
| Skewness | 0.52507914 |
| Sum | 301442 |
| Variance | 1917.1878 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 146 | 33 | 1.7% |
| 147 | 33 | 1.7% |
| 140 | 33 | 1.7% |
| 142 | 31 | 1.6% |
| 141 | 29 | 1.5% |
| 148 | 27 | 1.4% |
| 143 | 25 | 1.2% |
| 144 | 25 | 1.2% |
| 145 | 23 | 1.1% |
| 91 | 23 | 1.1% |
| Other values (195) | 1718 |
| Value | Count | Frequency (%) |
| 60 | 1 | 0.1% |
| 61 | 3 | 0.1% |
| 62 | 2 | 0.1% |
| 63 | 3 | 0.1% |
| 64 | 1 | 0.1% |
| 67 | 3 | 0.1% |
| 68 | 1 | 0.1% |
| 69 | 2 | 0.1% |
| 70 | 1 | 0.1% |
| 71 | 8 |
| Value | Count | Frequency (%) |
| 299 | 3 | |
| 297 | 2 | |
| 295 | 2 | |
| 292 | 2 | |
| 291 | 1 | 0.1% |
| 289 | 1 | 0.1% |
| 288 | 1 | 0.1% |
| 287 | 1 | 0.1% |
| 284 | 1 | 0.1% |
| 283 | 1 | 0.1% |
bedrooms
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
| 2 | |
|---|---|
| 3 | |
| 4 | 90 |
| 1 | 90 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 3 |
| 3rd row | 2 |
| 4th row | 3 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 924 | |
| 3 | 896 | |
| 4 | 90 | 4.5% |
| 1 | 90 | 4.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 924 | |
| 3 | 896 | |
| 4 | 90 | 4.5% |
| 1 | 90 | 4.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 924 | |
| 3 | 896 | |
| 4 | 90 | 4.5% |
| 1 | 90 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 924 | |
| 3 | 896 | |
| 4 | 90 | 4.5% |
| 1 | 90 | 4.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 924 | |
| 3 | 896 | |
| 4 | 90 | 4.5% |
| 1 | 90 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 924 | |
| 3 | 896 | |
| 4 | 90 | 4.5% |
| 1 | 90 | 4.5% |
bathrooms
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
| 3 | |
|---|---|
| 2 | |
| 4 | |
| 1 | |
| 5 | 29 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 4 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 797 | |
| 2 | 586 | |
| 4 | 381 | |
| 1 | 207 | 10.3% |
| 5 | 29 | 1.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 797 | |
| 2 | 586 | |
| 4 | 381 | |
| 1 | 207 | 10.3% |
| 5 | 29 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 797 | |
| 2 | 586 | |
| 4 | 381 | |
| 1 | 207 | 10.3% |
| 5 | 29 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 797 | |
| 2 | 586 | |
| 4 | 381 | |
| 1 | 207 | 10.3% |
| 5 | 29 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 797 | |
| 2 | 586 | |
| 4 | 381 | |
| 1 | 207 | 10.3% |
| 5 | 29 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 797 | |
| 2 | 586 | |
| 4 | 381 | |
| 1 | 207 | 10.3% |
| 5 | 29 | 1.5% |
floor_number
Real number (ℝ)
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.175 |
| Minimum | 1 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 8 |
| Q3 | 12 |
| 95-th percentile | 15 |
| Maximum | 15 |
| Range | 14 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.2617433 |
|---|---|
| Coefficient of variation (CV) | 0.52131417 |
| Kurtosis | -1.1902351 |
| Mean | 8.175 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.041466921 |
| Sum | 16350 |
| Variance | 18.162456 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 12 | 162 | 8.1% |
| 5 | 153 | 7.6% |
| 8 | 147 | 7.3% |
| 13 | 143 | 7.1% |
| 6 | 141 | 7.0% |
| 15 | 137 | 6.9% |
| 3 | 132 | 6.6% |
| 10 | 131 | 6.6% |
| 11 | 131 | 6.6% |
| 14 | 126 | 6.3% |
| Other values (5) | 597 |
| Value | Count | Frequency (%) |
| 1 | 122 | |
| 2 | 106 | |
| 3 | 132 | |
| 4 | 123 | |
| 5 | 153 | |
| 6 | 141 | |
| 7 | 123 | |
| 8 | 147 | |
| 9 | 123 | |
| 10 | 131 |
| Value | Count | Frequency (%) |
| 15 | 137 | |
| 14 | 126 | |
| 13 | 143 | |
| 12 | 162 | |
| 11 | 131 | |
| 10 | 131 | |
| 9 | 123 | |
| 8 | 147 | |
| 7 | 123 | |
| 6 | 141 |
building_age_years
Real number (ℝ)
Zeros
| Distinct | 21 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.3175 |
| Minimum | 0 |
|---|---|
| Maximum | 20 |
| Zeros | 78 |
| Zeros (%) | 3.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 11 |
| Q3 | 15 |
| 95-th percentile | 20 |
| Maximum | 20 |
| Range | 20 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 6.0342273 |
|---|---|
| Coefficient of variation (CV) | 0.58485363 |
| Kurtosis | -1.2086138 |
| Mean | 10.3175 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.054189325 |
| Sum | 20635 |
| Variance | 36.4119 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 15 | 112 | 5.6% |
| 6 | 110 | 5.5% |
| 12 | 109 | 5.5% |
| 13 | 107 | 5.3% |
| 20 | 106 | 5.3% |
| 19 | 105 | 5.2% |
| 7 | 100 | 5.0% |
| 8 | 100 | 5.0% |
| 14 | 99 | 5.0% |
| 16 | 99 | 5.0% |
| Other values (11) | 953 |
| Value | Count | Frequency (%) |
| 0 | 78 | |
| 1 | 97 | |
| 2 | 79 | |
| 3 | 92 | |
| 4 | 89 | |
| 5 | 93 | |
| 6 | 110 | |
| 7 | 100 | |
| 8 | 100 | |
| 9 | 81 |
| Value | Count | Frequency (%) |
| 20 | 106 | |
| 19 | 105 | |
| 18 | 90 | |
| 17 | 98 | |
| 16 | 99 | |
| 15 | 112 | |
| 14 | 99 | |
| 13 | 107 | |
| 12 | 109 | |
| 11 | 84 |
district
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
| Fifth Settlement | |
|---|---|
| Rehab City | |
| Katameya | |
| Madinaty | |
| New Cairo (Other) |
Length
| Max length | 17 |
|---|---|
| Median length | 16 |
| Mean length | 11.75 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Madinaty |
|---|---|
| 2nd row | Fifth Settlement |
| 3rd row | Rehab City |
| 4th row | Katameya |
| 5th row | Rehab City |
Common Values
| Value | Count | Frequency (%) |
| Fifth Settlement | 700 | |
| Rehab City | 500 | |
| Katameya | 400 | |
| Madinaty | 300 | |
| New Cairo (Other) | 100 | 5.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| fifth | 700 | |
| settlement | 700 | |
| rehab | 500 | |
| city | 500 | |
| katameya | 400 | |
| madinaty | 300 | |
| new | 100 | 2.9% |
| cairo | 100 | 2.9% |
| other | 100 | 2.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 4100 | |
| e | 3200 | |
| a | 2400 | |
| i | 1600 | 6.8% |
| 1400 | 6.0% | |
| h | 1300 | 5.5% |
| y | 1200 | 5.1% |
| m | 1100 | 4.7% |
| n | 1000 | 4.3% |
| F | 700 | 3.0% |
| Other values (16) | 5500 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 23500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 4100 | |
| e | 3200 | |
| a | 2400 | |
| i | 1600 | 6.8% |
| 1400 | 6.0% | |
| h | 1300 | 5.5% |
| y | 1200 | 5.1% |
| m | 1100 | 4.7% |
| n | 1000 | 4.3% |
| F | 700 | 3.0% |
| Other values (16) | 5500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 23500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 4100 | |
| e | 3200 | |
| a | 2400 | |
| i | 1600 | 6.8% |
| 1400 | 6.0% | |
| h | 1300 | 5.5% |
| y | 1200 | 5.1% |
| m | 1100 | 4.7% |
| n | 1000 | 4.3% |
| F | 700 | 3.0% |
| Other values (16) | 5500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 23500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 4100 | |
| e | 3200 | |
| a | 2400 | |
| i | 1600 | 6.8% |
| 1400 | 6.0% | |
| h | 1300 | 5.5% |
| y | 1200 | 5.1% |
| m | 1100 | 4.7% |
| n | 1000 | 4.3% |
| F | 700 | 3.0% |
| Other values (16) | 5500 |
compound_name
Categorical
High correlation Missing
| Distinct | 18 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 471 |
| Missing (%) | 23.5% |
| Memory size | 15.8 KiB |
| Mountain View | |
|---|---|
| Hyde Park | |
| Palm Hills | |
| Moon Valley | |
| Rehab 3 | |
| Other values (13) |
Length
| Max length | 16 |
|---|---|
| Median length | 14 |
| Mean length | 10.389797 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Lake View |
|---|---|
| 2nd row | Rehab 3 |
| 3rd row | Rehab 4 |
| 4th row | Katameya Plaza |
| 5th row | Madinaty B2 |
Common Values
| Value | Count | Frequency (%) |
| Mountain View | 146 | 7.3% |
| Hyde Park | 136 | 6.8% |
| Palm Hills | 135 | 6.8% |
| Moon Valley | 134 | 6.7% |
| Rehab 3 | 114 | 5.7% |
| Rehab 2 | 97 | 4.9% |
| Rehab 1 | 96 | 4.8% |
| Rehab 4 | 90 | 4.5% |
| Katameya Heights | 82 | 4.1% |
| Lake View | 80 | 4.0% |
| Other values (8) | 419 | |
| (Missing) | 471 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| rehab | 397 | 13.0% |
| madinaty | 233 | 7.6% |
| katameya | 227 | 7.4% |
| view | 226 | 7.4% |
| mountain | 146 | 4.8% |
| hyde | 136 | 4.4% |
| park | 136 | 4.4% |
| hills | 135 | 4.4% |
| palm | 135 | 4.4% |
| moon | 134 | 4.4% |
| Other values (17) | 1153 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2381 | |
| 1529 | 9.6% | |
| e | 1394 | 8.8% |
| i | 904 | 5.7% |
| n | 764 | 4.8% |
| y | 754 | 4.7% |
| l | 747 | 4.7% |
| t | 712 | 4.5% |
| M | 537 | 3.4% |
| h | 479 | 3.0% |
| Other values (27) | 5685 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15886 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2381 | |
| 1529 | 9.6% | |
| e | 1394 | 8.8% |
| i | 904 | 5.7% |
| n | 764 | 4.8% |
| y | 754 | 4.7% |
| l | 747 | 4.7% |
| t | 712 | 4.5% |
| M | 537 | 3.4% |
| h | 479 | 3.0% |
| Other values (27) | 5685 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15886 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2381 | |
| 1529 | 9.6% | |
| e | 1394 | 8.8% |
| i | 904 | 5.7% |
| n | 764 | 4.8% |
| y | 754 | 4.7% |
| l | 747 | 4.7% |
| t | 712 | 4.5% |
| M | 537 | 3.4% |
| h | 479 | 3.0% |
| Other values (27) | 5685 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15886 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2381 | |
| 1529 | 9.6% | |
| e | 1394 | 8.8% |
| i | 904 | 5.7% |
| n | 764 | 4.8% |
| y | 754 | 4.7% |
| l | 747 | 4.7% |
| t | 712 | 4.5% |
| M | 537 | 3.4% |
| h | 479 | 3.0% |
| Other values (27) | 5685 |
distance_to_auc_km
Real number (ℝ)
| Distinct | 231 |
|---|---|
| Distinct (%) | 11.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.4911 |
| Minimum | 2 |
|---|---|
| Maximum | 25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3.2 |
| Q1 | 7.7 |
| median | 13.2 |
| Q3 | 19.4 |
| 95-th percentile | 23.8 |
| Maximum | 25 |
| Range | 23 |
| Interquartile range (IQR) | 11.7 |
Descriptive statistics
| Standard deviation | 6.6885371 |
|---|---|
| Coefficient of variation (CV) | 0.49577404 |
| Kurtosis | -1.2272539 |
| Mean | 13.4911 |
| Median Absolute Deviation (MAD) | 5.9 |
| Skewness | 0.014661098 |
| Sum | 26982.2 |
| Variance | 44.736529 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16.1 | 18 | 0.9% |
| 17.6 | 17 | 0.9% |
| 8.3 | 17 | 0.9% |
| 19.4 | 17 | 0.9% |
| 4.3 | 16 | 0.8% |
| 9.2 | 15 | 0.8% |
| 20.2 | 15 | 0.8% |
| 23.3 | 15 | 0.8% |
| 21.2 | 15 | 0.8% |
| 7 | 14 | 0.7% |
| Other values (221) | 1841 |
| Value | Count | Frequency (%) |
| 2 | 2 | 0.1% |
| 2.1 | 11 | |
| 2.2 | 6 | |
| 2.3 | 10 | |
| 2.4 | 8 | |
| 2.5 | 10 | |
| 2.6 | 8 | |
| 2.7 | 8 | |
| 2.8 | 7 | |
| 2.9 | 9 |
| Value | Count | Frequency (%) |
| 25 | 7 | |
| 24.9 | 5 | 0.2% |
| 24.8 | 14 | |
| 24.7 | 13 | |
| 24.6 | 7 | |
| 24.5 | 10 | |
| 24.4 | 5 | 0.2% |
| 24.3 | 9 | |
| 24.2 | 3 | 0.1% |
| 24.1 | 5 | 0.2% |
distance_to_mall_km
Real number (ℝ)
| Distinct | 76 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2587 |
| Minimum | 0.5 |
|---|---|
| Maximum | 8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 0.8 |
| Q1 | 2.3 |
| median | 4.2 |
| Q3 | 6.2 |
| 95-th percentile | 7.7 |
| Maximum | 8 |
| Range | 7.5 |
| Interquartile range (IQR) | 3.9 |
Descriptive statistics
| Standard deviation | 2.1998759 |
|---|---|
| Coefficient of variation (CV) | 0.51656043 |
| Kurtosis | -1.2186124 |
| Mean | 4.2587 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.02252415 |
| Sum | 8517.4 |
| Variance | 4.839454 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.9 | 51 | 2.5% |
| 7.2 | 38 | 1.9% |
| 7.7 | 37 | 1.8% |
| 4.4 | 35 | 1.8% |
| 0.8 | 35 | 1.8% |
| 1.8 | 34 | 1.7% |
| 3.7 | 33 | 1.7% |
| 7.9 | 33 | 1.7% |
| 1.2 | 33 | 1.7% |
| 6.3 | 33 | 1.7% |
| Other values (66) | 1638 |
| Value | Count | Frequency (%) |
| 0.5 | 12 | 0.6% |
| 0.6 | 32 | |
| 0.7 | 24 | |
| 0.8 | 35 | |
| 0.9 | 18 | |
| 1 | 29 | |
| 1.1 | 27 | |
| 1.2 | 33 | |
| 1.3 | 24 | |
| 1.4 | 23 |
| Value | Count | Frequency (%) |
| 8 | 15 | 0.8% |
| 7.9 | 33 | |
| 7.8 | 30 | |
| 7.7 | 37 | |
| 7.6 | 25 | |
| 7.5 | 30 | |
| 7.4 | 24 | |
| 7.3 | 12 | 0.6% |
| 7.2 | 38 | |
| 7.1 | 32 |
distance_to_metro_km
Real number (ℝ)
| Distinct | 121 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.0025 |
| Minimum | 3 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.5 |
| Q1 | 6 |
| median | 9.1 |
| Q3 | 12 |
| 95-th percentile | 14.3 |
| Maximum | 15 |
| Range | 12 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.4651461 |
|---|---|
| Coefficient of variation (CV) | 0.38490931 |
| Kurtosis | -1.1810264 |
| Mean | 9.0025 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.03727291 |
| Sum | 18005 |
| Variance | 12.007237 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11.2 | 27 | 1.4% |
| 3.9 | 26 | 1.3% |
| 8.9 | 26 | 1.3% |
| 7.7 | 25 | 1.2% |
| 7.1 | 24 | 1.2% |
| 14.2 | 23 | 1.1% |
| 13.9 | 23 | 1.1% |
| 10.7 | 23 | 1.1% |
| 3.4 | 23 | 1.1% |
| 11.6 | 22 | 1.1% |
| Other values (111) | 1758 |
| Value | Count | Frequency (%) |
| 3 | 8 | 0.4% |
| 3.1 | 17 | |
| 3.2 | 15 | |
| 3.3 | 22 | |
| 3.4 | 23 | |
| 3.5 | 22 | |
| 3.6 | 20 | |
| 3.7 | 20 | |
| 3.8 | 16 | |
| 3.9 | 26 |
| Value | Count | Frequency (%) |
| 15 | 13 | |
| 14.9 | 17 | |
| 14.8 | 13 | |
| 14.7 | 10 | |
| 14.6 | 14 | |
| 14.5 | 12 | |
| 14.4 | 12 | |
| 14.3 | 17 | |
| 14.2 | 23 | |
| 14.1 | 14 |
finishing_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
| Lux | |
|---|---|
| Semi-finished | |
| Super Lux | |
| Unfinished |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 7.804 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Lux |
|---|---|
| 2nd row | Lux |
| 3rd row | Lux |
| 4th row | Lux |
| 5th row | Lux |
Common Values
| Value | Count | Frequency (%) |
| Lux | 796 | |
| Semi-finished | 545 | |
| Super Lux | 455 | |
| Unfinished | 204 | 10.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lux | 1251 | |
| semi-finished | 545 | |
| super | 455 | 18.5% |
| unfinished | 204 | 8.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 2043 | |
| e | 1749 | |
| u | 1706 | |
| L | 1251 | 8.0% |
| x | 1251 | 8.0% |
| S | 1000 | 6.4% |
| n | 953 | 6.1% |
| s | 749 | 4.8% |
| f | 749 | 4.8% |
| h | 749 | 4.8% |
| Other values (7) | 3408 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15608 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 2043 | |
| e | 1749 | |
| u | 1706 | |
| L | 1251 | 8.0% |
| x | 1251 | 8.0% |
| S | 1000 | 6.4% |
| n | 953 | 6.1% |
| s | 749 | 4.8% |
| f | 749 | 4.8% |
| h | 749 | 4.8% |
| Other values (7) | 3408 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15608 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 2043 | |
| e | 1749 | |
| u | 1706 | |
| L | 1251 | 8.0% |
| x | 1251 | 8.0% |
| S | 1000 | 6.4% |
| n | 953 | 6.1% |
| s | 749 | 4.8% |
| f | 749 | 4.8% |
| h | 749 | 4.8% |
| Other values (7) | 3408 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15608 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 2043 | |
| e | 1749 | |
| u | 1706 | |
| L | 1251 | 8.0% |
| x | 1251 | 8.0% |
| S | 1000 | 6.4% |
| n | 953 | 6.1% |
| s | 749 | 4.8% |
| f | 749 | 4.8% |
| h | 749 | 4.8% |
| Other values (7) | 3408 |
| Value | Count | Frequency (%) |
| True | 1493 | |
| False | 507 | 25.4% |
| Value | Count | Frequency (%) |
| True | 1342 | |
| False | 658 |
| Value | Count | Frequency (%) |
| True | 1618 | |
| False | 382 | 19.1% |
| Value | Count | Frequency (%) |
| True | 1206 | |
| False | 794 |
view_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
| Street | |
|---|---|
| Garden | |
| Compound | |
| Nile | 31 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.396 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Garden |
|---|---|
| 2nd row | Compound |
| 3rd row | Garden |
| 4th row | Street |
| 5th row | Street |
Common Values
| Value | Count | Frequency (%) |
| Street | 846 | |
| Garden | 696 | |
| Compound | 427 | |
| Nile | 31 | 1.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| street | 846 | |
| garden | 696 | |
| compound | 427 | |
| nile | 31 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2419 | |
| t | 1692 | |
| r | 1542 | |
| n | 1123 | |
| d | 1123 | |
| o | 854 | 6.7% |
| S | 846 | 6.6% |
| a | 696 | 5.4% |
| G | 696 | 5.4% |
| C | 427 | 3.3% |
| Other values (6) | 1374 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12792 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 2419 | |
| t | 1692 | |
| r | 1542 | |
| n | 1123 | |
| d | 1123 | |
| o | 854 | 6.7% |
| S | 846 | 6.6% |
| a | 696 | 5.4% |
| G | 696 | 5.4% |
| C | 427 | 3.3% |
| Other values (6) | 1374 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12792 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 2419 | |
| t | 1692 | |
| r | 1542 | |
| n | 1123 | |
| d | 1123 | |
| o | 854 | 6.7% |
| S | 846 | 6.6% |
| a | 696 | 5.4% |
| G | 696 | 5.4% |
| C | 427 | 3.3% |
| Other values (6) | 1374 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12792 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 2419 | |
| t | 1692 | |
| r | 1542 | |
| n | 1123 | |
| d | 1123 | |
| o | 854 | 6.7% |
| S | 846 | 6.6% |
| a | 696 | 5.4% |
| G | 696 | 5.4% |
| C | 427 | 3.3% |
| Other values (6) | 1374 |
listing_date
Date
| Distinct | 180 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
| Minimum | 2025-05-11 00:00:00 |
|---|---|
| Maximum | 2025-11-06 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
days_on_market
Real number (ℝ)
| Distinct | 180 |
|---|---|
| Distinct (%) | 9.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.43 |
| Minimum | 1 |
|---|---|
| Maximum | 180 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 45.75 |
| median | 88 |
| Q3 | 133 |
| 95-th percentile | 172 |
| Maximum | 180 |
| Range | 179 |
| Interquartile range (IQR) | 87.25 |
Descriptive statistics
| Standard deviation | 51.960225 |
|---|---|
| Coefficient of variation (CV) | 0.5810156 |
| Kurtosis | -1.1890491 |
| Mean | 89.43 |
| Median Absolute Deviation (MAD) | 44 |
| Skewness | 0.028396632 |
| Sum | 178860 |
| Variance | 2699.865 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10 | 18 | 0.9% |
| 128 | 18 | 0.9% |
| 13 | 18 | 0.9% |
| 6 | 18 | 0.9% |
| 108 | 18 | 0.9% |
| 151 | 17 | 0.9% |
| 46 | 17 | 0.9% |
| 68 | 17 | 0.9% |
| 163 | 17 | 0.9% |
| 62 | 17 | 0.9% |
| Other values (170) | 1825 |
| Value | Count | Frequency (%) |
| 1 | 13 | |
| 2 | 11 | |
| 3 | 11 | |
| 4 | 13 | |
| 5 | 9 | |
| 6 | 18 | |
| 7 | 11 | |
| 8 | 10 | |
| 9 | 5 | 0.2% |
| 10 | 18 |
| Value | Count | Frequency (%) |
| 180 | 13 | |
| 179 | 5 | 0.2% |
| 178 | 9 | |
| 177 | 12 | |
| 176 | 15 | |
| 175 | 14 | |
| 174 | 11 | |
| 173 | 15 | |
| 172 | 11 | |
| 171 | 12 |
seller_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.8 KiB |
| Broker | |
|---|---|
| Owner |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.6565 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Broker |
|---|---|
| 2nd row | Broker |
| 3rd row | Broker |
| 4th row | Broker |
| 5th row | Owner |
Common Values
| Value | Count | Frequency (%) |
| Broker | 1313 | |
| Owner | 687 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| broker | 1313 | |
| owner | 687 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 3313 | |
| e | 2000 | |
| o | 1313 | 11.6% |
| B | 1313 | 11.6% |
| k | 1313 | 11.6% |
| O | 687 | 6.1% |
| w | 687 | 6.1% |
| n | 687 | 6.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11313 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 3313 | |
| e | 2000 | |
| o | 1313 | 11.6% |
| B | 1313 | 11.6% |
| k | 1313 | 11.6% |
| O | 687 | 6.1% |
| w | 687 | 6.1% |
| n | 687 | 6.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11313 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 3313 | |
| e | 2000 | |
| o | 1313 | 11.6% |
| B | 1313 | 11.6% |
| k | 1313 | 11.6% |
| O | 687 | 6.1% |
| w | 687 | 6.1% |
| n | 687 | 6.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11313 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 3313 | |
| e | 2000 | |
| o | 1313 | 11.6% |
| B | 1313 | 11.6% |
| k | 1313 | 11.6% |
| O | 687 | 6.1% |
| w | 687 | 6.1% |
| n | 687 | 6.1% |
| Value | Count | Frequency (%) |
| True | 1694 | |
| False | 306 | 15.3% |
Interactions
Correlations
| area_sqm | bathrooms | bedrooms | building_age_years | compound_name | days_on_market | distance_to_auc_km | distance_to_mall_km | distance_to_metro_km | district | finishing_type | floor_number | has_amenities | has_balcony | has_parking | has_security | is_negotiable | price_egp | seller_type | view_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| area_sqm | 1.000 | 0.382 | 0.820 | -0.005 | 0.000 | -0.043 | 0.003 | 0.020 | -0.008 | 0.000 | 0.000 | 0.033 | 0.000 | 0.037 | 0.067 | 0.036 | 0.074 | 0.851 | 0.000 | 0.035 |
| bathrooms | 0.382 | 1.000 | 0.518 | 0.037 | 0.065 | 0.029 | 0.021 | 0.000 | 0.035 | 0.009 | 0.037 | 0.000 | 0.000 | 0.000 | 0.000 | 0.041 | 0.005 | 0.332 | 0.000 | 0.042 |
| bedrooms | 0.820 | 0.518 | 1.000 | 0.059 | 0.000 | 0.032 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.054 | 0.039 | 0.022 | 0.619 | 0.043 | 0.021 |
| building_age_years | -0.005 | 0.037 | 0.059 | 1.000 | 0.000 | -0.001 | -0.005 | -0.030 | 0.004 | 0.004 | 0.055 | 0.030 | 0.041 | 0.038 | 0.000 | 0.000 | 0.048 | -0.146 | 0.059 | 0.044 |
| compound_name | 0.000 | 0.065 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.996 | 0.009 | 0.041 | 0.000 | 0.000 | 0.000 | 0.072 | 0.073 | 0.000 | 0.000 | 0.033 |
| days_on_market | -0.043 | 0.029 | 0.032 | -0.001 | 0.000 | 1.000 | 0.006 | -0.011 | 0.029 | 0.000 | 0.013 | 0.005 | 0.039 | 0.000 | 0.000 | 0.000 | 0.061 | -0.029 | 0.000 | 0.017 |
| distance_to_auc_km | 0.003 | 0.021 | 0.000 | -0.005 | 0.000 | 0.006 | 1.000 | 0.030 | -0.013 | 0.000 | 0.017 | 0.007 | 0.000 | 0.048 | 0.056 | 0.045 | 0.000 | -0.040 | 0.058 | 0.000 |
| distance_to_mall_km | 0.020 | 0.000 | 0.000 | -0.030 | 0.000 | -0.011 | 0.030 | 1.000 | -0.035 | 0.030 | 0.028 | -0.005 | 0.057 | 0.048 | 0.000 | 0.000 | 0.000 | -0.008 | 0.000 | 0.000 |
| distance_to_metro_km | -0.008 | 0.035 | 0.000 | 0.004 | 0.000 | 0.029 | -0.013 | -0.035 | 1.000 | 0.000 | 0.000 | 0.030 | 0.000 | 0.000 | 0.033 | 0.000 | 0.035 | 0.014 | 0.027 | 0.011 |
| district | 0.000 | 0.009 | 0.000 | 0.004 | 0.996 | 0.000 | 0.000 | 0.030 | 0.000 | 1.000 | 0.000 | 0.029 | 0.000 | 0.000 | 0.000 | 0.000 | 0.070 | 0.000 | 0.000 | 0.000 |
| finishing_type | 0.000 | 0.037 | 0.000 | 0.055 | 0.009 | 0.013 | 0.017 | 0.028 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.024 | 0.030 | 0.000 | 0.000 | 0.165 | 0.000 | 0.000 |
| floor_number | 0.033 | 0.000 | 0.000 | 0.030 | 0.041 | 0.005 | 0.007 | -0.005 | 0.030 | 0.029 | 0.000 | 1.000 | 0.000 | 0.000 | 0.044 | 0.000 | 0.000 | -0.007 | 0.043 | 0.000 |
| has_amenities | 0.000 | 0.000 | 0.000 | 0.041 | 0.000 | 0.039 | 0.000 | 0.057 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.012 | 0.017 | 0.000 | 0.138 | 0.000 | 0.000 |
| has_balcony | 0.037 | 0.000 | 0.000 | 0.038 | 0.000 | 0.000 | 0.048 | 0.048 | 0.000 | 0.000 | 0.024 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.013 |
| has_parking | 0.067 | 0.000 | 0.054 | 0.000 | 0.000 | 0.000 | 0.056 | 0.000 | 0.033 | 0.000 | 0.030 | 0.044 | 0.012 | 0.000 | 1.000 | 0.000 | 0.006 | 0.020 | 0.000 | 0.000 |
| has_security | 0.036 | 0.041 | 0.039 | 0.000 | 0.072 | 0.000 | 0.045 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.017 | 0.000 | 0.000 | 1.000 | 0.017 | 0.000 | 0.000 | 0.000 |
| is_negotiable | 0.074 | 0.005 | 0.022 | 0.048 | 0.073 | 0.061 | 0.000 | 0.000 | 0.035 | 0.070 | 0.000 | 0.000 | 0.000 | 0.000 | 0.006 | 0.017 | 1.000 | 0.036 | 0.000 | 0.030 |
| price_egp | 0.851 | 0.332 | 0.619 | -0.146 | 0.000 | -0.029 | -0.040 | -0.008 | 0.014 | 0.000 | 0.165 | -0.007 | 0.138 | 0.000 | 0.020 | 0.000 | 0.036 | 1.000 | 0.000 | 0.044 |
| seller_type | 0.000 | 0.000 | 0.043 | 0.059 | 0.000 | 0.000 | 0.058 | 0.000 | 0.027 | 0.000 | 0.000 | 0.043 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 |
| view_type | 0.035 | 0.042 | 0.021 | 0.044 | 0.033 | 0.017 | 0.000 | 0.000 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.013 | 0.000 | 0.000 | 0.030 | 0.044 | 0.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| listing_id | price_egp | area_sqm | bedrooms | bathrooms | floor_number | building_age_years | district | compound_name | distance_to_auc_km | distance_to_mall_km | distance_to_metro_km | finishing_type | has_balcony | has_parking | has_security | has_amenities | view_type | listing_date | days_on_market | seller_type | is_negotiable | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NCR-2024-00001 | 3650000 | 145 | 3 | 2 | 12 | 18 | Madinaty | NaN | 15.9 | 2.1 | 13.1 | Lux | Yes | Yes | Yes | No | Garden | 2025-08-23 | 76 | Broker | Yes |
| 1 | NCR-2024-00002 | 3900000 | 155 | 3 | 3 | 15 | 17 | Fifth Settlement | NaN | 23.8 | 3.0 | 6.4 | Lux | Yes | Yes | Yes | Yes | Compound | 2025-08-12 | 87 | Broker | Yes |
| 2 | NCR-2024-00003 | 2650000 | 109 | 2 | 3 | 5 | 14 | Rehab City | NaN | 9.8 | 7.7 | 9.9 | Lux | Yes | Yes | Yes | Yes | Garden | 2025-09-20 | 48 | Broker | Yes |
| 3 | NCR-2024-00004 | 5450000 | 219 | 3 | 4 | 10 | 1 | Katameya | Lake View | 4.5 | 4.4 | 4.5 | Lux | Yes | Yes | Yes | Yes | Street | 2025-09-10 | 58 | Broker | Yes |
| 4 | NCR-2024-00005 | 2450000 | 96 | 2 | 3 | 4 | 13 | Rehab City | Rehab 3 | 13.6 | 3.5 | 11.3 | Lux | Yes | No | Yes | No | Street | 2025-09-11 | 57 | Owner | Yes |
| 5 | NCR-2024-00006 | 3000000 | 130 | 2 | 3 | 2 | 20 | Rehab City | Rehab 4 | 4.0 | 4.4 | 11.8 | Lux | Yes | Yes | Yes | Yes | Compound | 2025-08-27 | 72 | Owner | Yes |
| 6 | NCR-2024-00007 | 3100000 | 103 | 2 | 3 | 4 | 9 | Katameya | Katameya Plaza | 24.3 | 6.3 | 3.5 | Lux | Yes | Yes | Yes | Yes | Compound | 2025-07-21 | 109 | Owner | Yes |
| 7 | NCR-2024-00008 | 5550000 | 242 | 4 | 4 | 12 | 15 | Madinaty | Madinaty B2 | 2.9 | 3.1 | 11.1 | Semi-finished | Yes | No | Yes | Yes | Garden | 2025-07-14 | 116 | Broker | No |
| 8 | NCR-2024-00009 | 4000000 | 165 | 3 | 4 | 8 | 6 | Fifth Settlement | Hyde Park | 19.3 | 1.8 | 8.0 | Lux | No | No | Yes | No | Street | 2025-07-28 | 102 | Owner | Yes |
| 9 | NCR-2024-00010 | 6750000 | 217 | 3 | 4 | 5 | 7 | Rehab City | Rehab 1 | 14.1 | 4.9 | 4.5 | Super Lux | Yes | No | No | Yes | Garden | 2025-08-06 | 93 | Broker | Yes |
| listing_id | price_egp | area_sqm | bedrooms | bathrooms | floor_number | building_age_years | district | compound_name | distance_to_auc_km | distance_to_mall_km | distance_to_metro_km | finishing_type | has_balcony | has_parking | has_security | has_amenities | view_type | listing_date | days_on_market | seller_type | is_negotiable | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1990 | NCR-2024-01991 | 4150000 | 158 | 3 | 3 | 1 | 4 | Fifth Settlement | Moon Valley | 13.9 | 3.5 | 7.5 | Semi-finished | Yes | Yes | Yes | Yes | Garden | 2025-07-24 | 106 | Broker | Yes |
| 1991 | NCR-2024-01992 | 4650000 | 166 | 3 | 3 | 10 | 10 | Madinaty | Madinaty B1 | 7.2 | 6.8 | 13.8 | Unfinished | Yes | No | No | Yes | Garden | 2025-06-01 | 159 | Broker | Yes |
| 1992 | NCR-2024-01993 | 3900000 | 140 | 3 | 3 | 11 | 7 | Katameya | Katameya Plaza | 11.4 | 6.0 | 3.2 | Super Lux | Yes | Yes | No | Yes | Street | 2025-06-16 | 144 | Broker | Yes |
| 1993 | NCR-2024-01994 | 4900000 | 172 | 3 | 2 | 7 | 4 | Madinaty | Madinaty B4 | 22.2 | 6.1 | 11.4 | Super Lux | Yes | Yes | Yes | Yes | Street | 2025-07-06 | 124 | Broker | Yes |
| 1994 | NCR-2024-01995 | 3600000 | 129 | 2 | 3 | 3 | 10 | Katameya | Katameya Heights | 14.1 | 2.0 | 14.5 | Lux | No | Yes | Yes | No | Street | 2025-09-01 | 67 | Broker | Yes |
| 1995 | NCR-2024-01996 | 3600000 | 121 | 2 | 3 | 9 | 4 | Rehab City | NaN | 9.7 | 4.0 | 11.5 | Lux | No | Yes | Yes | Yes | Street | 2025-09-27 | 41 | Broker | Yes |
| 1996 | NCR-2024-01997 | 2300000 | 94 | 2 | 3 | 6 | 16 | Rehab City | Rehab 1 | 6.8 | 7.0 | 14.9 | Semi-finished | Yes | No | Yes | Yes | Garden | 2025-09-22 | 46 | Owner | Yes |
| 1997 | NCR-2024-01998 | 4100000 | 156 | 3 | 2 | 5 | 3 | Katameya | Katameya Plaza | 20.4 | 4.3 | 11.3 | Super Lux | Yes | Yes | No | No | Garden | 2025-08-21 | 78 | Owner | Yes |
| 1998 | NCR-2024-01999 | 2050000 | 97 | 2 | 3 | 8 | 14 | Rehab City | NaN | 16.4 | 5.6 | 3.4 | Unfinished | Yes | Yes | Yes | No | Garden | 2025-06-20 | 140 | Broker | Yes |
| 1999 | NCR-2024-02000 | 5400000 | 196 | 3 | 4 | 8 | 18 | Rehab City | Rehab 1 | 12.8 | 4.9 | 12.9 | Lux | No | Yes | Yes | Yes | Street | 2025-10-09 | 29 | Broker | Yes |